Date Grouping
Records that exist within dataset columns that are configured as a Date column type can be grouped into common date group buckets. Drag and drop a category field of type Date onto the Category shelf, select the options (three-dot) menu and select Date Group. Select a date group bucket to redraw the chart with that date grouping applied.
The following date group buckets are available for Date fields within the Chart Builder:
| Type | Description | Display Format | Example |
|---|---|---|---|
| Year | Year component of the date value. | 4-digit year | 2021 |
| Quarter, Year | Quarter of a specific year. | Q letter prefix, followed by a number between 1 and 4, then a space and the 4-digit year. | Q4 2021 |
| Month, Year | Month of a specific year. | Three-letter month prefix, followed by a space and then the 4-digit year. | Aug 2021 |
| Week, Year | Week of a specific year. | W letter prefix, followed by a number between 1 and 52, then a space and the 4-digit year. | W26 2021 |
| Full Date | Actual date value. | Follows the corresponding setting for the field within the source dataset (for example, MM/DD/YYYY). | 10/01/2021 |
| Date, Hour* | Hour of a specific date. | Follows the corresponding setting for the field within the source dataset; minutes and seconds are ignored (for example, MM/DD/YYYY HH24:00:00). | 10/01/2021 18:00:00 |
| Date, Minute* | Minute of a specific hour and date. | Follows the corresponding setting for the field within the source dataset; seconds are ignored (for example, MM/DD/YYYY HH24:MM:00). | 10/01/2021 18:45:00. |
| Date, Second* | Second of a specific minute, hour and date. | Follows the corresponding setting for the field within the source dataset (for example, MM/DD/YYYY HH24:MM:SS). | 10/01/2021 18:45:30 |
| Quarter | Specific quarter of any or all years in the dataset; for example, all data that falls within a specific quarter is grouped together for all years. | Q letter prefix, followed by a number between 1 and 4. | Q3 |
| Month | Specific month of any/all years in the dataset; for example, all data that falls within a specific month is grouped together for all years. | Three-letter month prefix. | Feb |
| Day (Year) | Specific day of any/all years in the dataset; for example, all data that falls within a specific day of the year is grouped together for all years. | One-, two-, or three-digit day of the year. (1-365) | 330 |
| Day (Month) | Specific day of any or all months in the dataset; for example, all data that falls within a specific day of the month is grouped together for all months. | One- or two--digit day of the month (1-31). | 15 |
| Day (Week) | Specific day of any or all weeks in the dataset; for example, all data that falls within a specific day of the week is grouped together for all weeks. | Three-letter day of week prefix. | Mon |
| Hour* | Specific hour of any or all days in the dataset; for example, all data that falls within a specific hour of the day is grouped together for all days. | One- or two-digit hour of the day (0-23). | 12 |
| Minute* | Specific minute of any or all hours in the dataset; for example, all data that falls within a specific minute of the hour is grouped together for all hours. | One- or two-digit minute of the hour (0-59). | 45 |
| Second* | Specific second of any or all minutes in the dataset; for example, all data that falls within a specific second of the minute is grouped together for all minutes. | One or two-digit second of the minute (0-59). | 25 |
*-Not available if the date field does not contain hours, minutes, and seconds.